home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1992-05-23 | 5.4 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 100%
| file
| data
| default
| |
| 100%
| gt2
| Kopftext: 'TED FRE'
| default (weak)
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 54 45 44 20 46 52 45 00 | c8 00 4e 00 32 00 09 00 |TED FRE.|..N.2...|
|00000010| 01 00 0b 00 20 20 49 66 | 20 79 6f 75 20 68 61 76 |.... If| you hav|
|00000020| 65 20 6e 6f 74 20 61 6c | 72 65 61 64 79 20 64 6f |e not al|ready do|
|00000030| 6e 65 20 73 6f 20 6c 6f | 61 64 20 74 68 65 20 66 |ne so lo|ad the f|
|00000040| 69 6c 65 20 22 54 41 42 | 4c 45 31 2e 4d 41 4b 22 |ile "TAB|LE1.MAK"|
|00000050| 20 73 6f 20 74 68 61 74 | 20 61 6c 6c 0e 06 00 4b | so that| all...K|
|00000060| 00 64 65 66 61 75 6c 74 | 73 20 77 69 6c 6c 20 62 |.default|s will b|
|00000070| 65 20 73 65 74 20 66 6f | 72 20 74 68 69 73 20 65 |e set fo|r this e|
|00000080| 78 61 6d 70 6c 65 2e 20 | 54 6f 20 64 6f 20 74 68 |xample. |To do th|
|00000090| 69 73 20 63 68 6f 6f 73 | 65 20 74 68 65 20 63 6f |is choos|e the co|
|000000a0| 6d 6d 61 6e 64 0e 0a 00 | 47 00 22 4d 61 6e 61 67 |mmand...|G."Manag|
|000000b0| 65 20 2e 2e 2e 22 20 66 | 72 6f 6d 20 74 68 65 20 |e ..." f|rom the |
|000000c0| 22 46 69 6c 65 22 20 6d | 65 6e 75 2e 20 46 72 6f |"File" m|enu. Fro|
|000000d0| 6d 20 74 68 69 73 20 70 | 6f 70 20 75 70 20 6d 65 |m this p|op up me|
|000000e0| 6e 75 20 63 68 6f 6f 73 | 65 20 74 68 65 20 6d 65 |nu choos|e the me|
|000000f0| 6e 75 20 69 74 65 6d 20 | 4e 00 22 6c 6f 61 64 20 |nu item |N."load |
|00000100| 4d 41 4b 22 20 61 6e 64 | 20 63 68 6f 6f 73 65 20 |MAK" and| choose |
|00000110| 74 68 65 20 66 69 6c 65 | 20 22 54 41 42 4c 45 31 |the file| "TABLE1|
|00000120| 2e 4d 41 4b 22 0e 23 00 | 2e 00 0e 4e 00 03 00 20 |.MAK".#.|...N... |
|00000130| 20 54 68 69 73 20 73 68 | 65 65 74 20 73 68 6f 77 | This sh|eet show|
|00000140| 73 20 68 6f 77 20 63 65 | 6c 6c 73 20 63 61 6e 20 |s how ce|lls can |
|00000150| 62 65 20 65 76 61 6c 75 | 61 74 65 64 20 69 6e 20 |be evalu|ated in |
|00000160| 64 69 66 66 65 72 65 6e | 74 20 77 61 79 73 2e 20 |differen|t ways. |
|00000170| 4a 75 73 74 20 75 73 65 | 20 74 68 65 20 4e 00 70 |Just use| the N.p|
|00000180| 61 67 65 20 64 6f 77 6e | 20 6b 65 79 20 74 6f 20 |age down| key to |
|00000190| 6c 6f 6f 6b 20 61 74 20 | 65 61 63 68 20 65 78 61 |look at |each exa|
|000001a0| 6d 70 6c 65 20 63 65 6c | 6c 2e 20 55 73 69 6e 67 |mple cel|l. Using|
|000001b0| 20 74 68 65 20 70 61 67 | 65 20 64 6f 77 6e 20 6b | the pag|e down k|
|000001c0| 65 79 20 77 69 6c 6c 20 | 62 72 69 6e 67 4e 00 74 |ey will |bringN.t|
|000001d0| 68 65 20 63 75 72 73 6f | 72 20 74 6f 20 74 68 65 |he curso|r to the|
|000001e0| 20 6e 65 78 74 20 63 65 | 6c 6c 2e 20 57 68 65 6e | next ce|ll. When|
|000001f0| 20 74 68 65 20 63 75 72 | 73 6f 72 20 69 73 20 6f | the cur|sor is o|
|00000200| 6e 20 74 68 65 20 63 65 | 6c 6c 20 79 6f 75 20 77 |n the ce|ll you w|
|00000210| 69 6c 6c 20 73 65 65 20 | 74 68 65 20 20 4e 00 63 |ill see |the N.c|
|00000220| 65 6c 6c 20 63 6f 6e 74 | 65 6e 74 73 20 61 6e 64 |ell cont|ents and|
|00000230| 20 63 65 6c 6c 20 6e 61 | 6d 65 20 28 69 66 20 61 | cell na|me (if a|
|00000240| 6e 79 29 20 69 6e 20 74 | 68 65 20 63 65 6c 6c 20 |ny) in t|he cell |
|00000250| 62 61 72 20 28 73 65 63 | 6f 6e 64 20 62 61 72 20 |bar (sec|ond bar |
|00000260| 66 72 6f 6d 20 74 68 65 | 20 74 6f 70 20 4e 00 6f |from the| top N.o|
|00000270| 66 20 74 68 65 20 73 63 | 72 65 65 6e 29 2e 0e 3f |f the sc|reen)..?|
|00000280| 00 12 00 0e 4e 00 03 00 | 0e 4e 00 03 00 0e 4e 00 |....N...|.N....N.|
|00000290| 03 00 0e 12 00 32 2e 37 | 36 0e 06 00 54 68 69 73 |.....2.7|6...This|
|000002a0| 20 66 69 72 73 74 20 63 | 65 6c 6c 20 73 68 6f 77 | first c|ell show|
|000002b0| 73 20 74 68 65 20 73 69 | 6d 70 6c 65 73 74 20 63 |s the si|mplest c|
|000002c0| 65 6c 6c 20 63 6f 6e 74 | 65 6e 74 73 2c 20 3c 00 |ell cont|ents, <.|
|000002d0| 0e 1c 00 6a 75 73 74 20 | 6e 75 6d 62 65 72 73 20 |...just |numbers |
|000002e0| 69 6e 20 74 68 65 20 63 | 65 6c 6c 20 63 6f 6e 74 |in the c|ell cont|
|000002f0| 65 6e 74 73 2e 20 4e 6f | 74 69 63 65 20 74 68 61 |ents. No|tice tha|
|00000300| 74 0e 04 00 34 00 0e 1c | 00 77 68 65 6e 20 74 68 |t...4...|.when th|
|00000310| 65 20 63 75 72 73 6f 72 | 20 69 73 20 6f 6e 20 74 |e cursor| is on t|
|00000320| 68 65 20 63 65 6c 6c 20 | 74 68 65 20 63 65 6c 6c |he cell |the cell|
|00000330| 20 63 6f 6e 74 65 6e 74 | 73 20 20 35 00 0e 1c 00 | content|s 5....|
|00000340| 61 72 65 20 73 68 6f 77 | 6e 20 6f 6e 20 74 68 65 |are show|n on the|
|00000350| 20 62 61 72 20 6a 75 73 | 74 20 75 6e 64 65 72 20 | bar jus|t under |
|00000360| 74 68 65 20 6d 65 6e 75 | 20 62 61 72 0e 06 00 32 |the menu| bar...2|
|00000370| 00 0e 1c 00 69 2e 65 2e | 20 32 2e 33 2a 31 2e 32 |....i.e.| 2.3*1.2|
|00000380| 20 69 6e 20 74 68 69 73 | 20 63 61 73 65 2e 20 54 | in this| case. T|
|00000390| 68 65 20 63 65 6c 6c 20 | 68 61 73 20 61 6c 73 6f |he cell |has also|
|000003a0| 20 62 65 65 6e 20 35 00 | 0e 1c 00 67 69 76 65 6e | been 5.|...given|
|000003b0| 20 61 20 6e 61 6d 65 2c | 20 69 2e 65 2e 20 22 63 | a name,| i.e. "c|
|000003c0| 65 6c 6c 31 22 20 77 68 | 69 63 68 20 63 61 6e 20 |ell1" wh|ich can |
|000003d0| 61 6c 73 6f 20 62 65 20 | 73 65 65 6e 20 35 00 0e |also be |seen 5..|
|000003e0| 1c 00 69 6e 20 74 68 65 | 20 63 65 6c 6c 20 62 61 |..in the| cell ba|
|000003f0| 72 2e 20 55 73 65 20 74 | 68 65 20 64 6f 77 6e 20 |r. Use t|he down |
|00000400| 61 72 72 6f 77 20 6b 65 | 79 20 74 6f 20 70 6c 61 |arrow ke|y to pla|
|00000410| 63 65 20 20 35 00 0e 1c | 00 74 68 65 20 63 75 72 |ce 5...|.the cur|
|00000420| 73 6f 72 20 6f 6e 20 74 | 68 65 20 6e 65 78 74 20 |sor on t|he next |
|00000430| 63 65 6c 6c 20 61 6e 64 | 20 63 6f 6e 74 69 6e 75 |cell and| continu|
|00000440| 65 20 6c 69 6b 65 20 74 | 68 69 73 35 00 0e 1c 00 |e like t|his5....|
|00000450| 75 6e 74 69 6c 20 74 68 | 65 20 65 6e 64 20 6f 66 |until th|e end of|
|00000460| 20 74 68 65 20 73 68 65 | 65 74 2e 0e 17 00 21 00 | the she|et....!.|
|00000470| 0e 4e 00 03 00 0e 1c 00 | 50 6c 65 61 73 65 20 70 |.N......|Please p|
|00000480| 72 65 73 73 20 74 68 65 | 20 70 61 67 65 20 64 6f |ress the| page do|
|00000490| 77 6e 20 6b 65 79 2e 0e | 13 00 25 00 0e 4e 00 03 |wn key..|..%..N..|
|000004a0| 00 0e 4e 00 03 00 0e 4e | 00 03 00 0e 4e 00 03 00 |..N....N|....N...|
|000004b0| 0e 4e 00 03 00 0e 4e 00 | 03 00 0e 4e 00 03 00 0e |.N....N.|...N....|
|000004c0| 4e 00 03 00 0e 4e 00 03 | 00 0e 12 00 33 2e 37 36 |N....N..|....3.76|
|000004d0| 0e 06 00 54 68 65 20 63 | 65 6c 6c 20 63 6f 6e 74 |...The c|ell cont|
|000004e0| 65 6e 74 73 20 6f 66 20 | 74 68 69 73 20 63 65 6c |ents of |this cel|
|000004f0| 6c 20 63 6f 6e 74 61 69 | 6e 20 61 20 72 65 66 65 |l contai|n a refe|
|00000500| 72 65 6e 63 65 3c 00 0e | 1c 00 74 6f 20 74 68 65 |rence<..|..to the|
|00000510| 20 76 61 6c 75 65 20 6f | 66 20 74 68 65 20 63 65 | value o|f the ce|
|00000520| 6c 6c 20 6a 75 73 74 20 | 61 62 6f 76 65 20 69 74 |ll just |above it|
|00000530| 2e 20 54 68 65 20 63 65 | 6c 6c 20 20 35 00 0e 1c |. The ce|ll 5...|
|00000540| 00 69 73 20 72 65 66 65 | 72 72 65 64 20 74 6f 20 |.is refe|rred to |
|00000550| 62 79 20 72 6f 77 20 28 | 30 30 31 34 29 20 61 6e |by row (|0014) an|
|00000560| 64 20 63 6f 6c 75 6d 6e | 20 28 30 30 30 38 29 2e |d column| (0008).|
|00000570| 20 20 20 35 00 0e 1c 00 | 54 68 65 20 76 61 6c 75 | 5....|The valu|
|00000580| 65 20 6f 66 20 74 68 69 | 73 20 63 65 6c 6c 20 61 |e of thi|s cell a|
|00000590| 62 6f 76 65 20 69 73 20 | 75 73 65 64 20 69 6e 20 |bove is |used in |
|000005a0| 74 68 65 0e 07 00 31 00 | 0e 1c 00 63 61 6c 63 75 |the...1.|...calcu|
|000005b0| 6c 61 74 69 6f 6e 73 20 | 74 6f 20 67 65 74 20 74 |lations |to get t|
|000005c0| 68 65 20 76 61 6c 75 65 | 20 6f 66 20 74 68 69 73 |he value| of this|
|000005d0| 20 63 65 6c 6c 2e 0e 07 | 00 31 00 0e 4e 00 03 00 | cell...|.1..N...|
|000005e0| 0e 1c 00 50 6c 65 61 73 | 65 20 70 72 65 73 73 20 |...Pleas|e press |
|000005f0| 74 68 65 20 70 61 67 65 | 20 64 6f 77 6e 20 6b 65 |the page| down ke|
|00000600| 79 2e 0e 13 00 25 00 0e | 4e 00 03 00 0e 4e 00 03 |y....%..|N....N..|
|00000610| 00 0e 4e 00 03 00 0e 4e | 00 03 00 0e 4e 00 03 00 |..N....N|....N...|
|00000620| 0e 4e 00 03 00 0e 4e 00 | 03 00 0e 4e 00 03 00 0e |.N....N.|...N....|
|00000630| 4e 00 03 00 0e 4e 00 03 | 00 0e 4e 00 03 00 0e 4e |N....N..|..N....N|
|00000640| 00 03 00 0e 4e 00 03 00 | 0e 12 00 33 2e 37 36 0e |....N...|...3.76.|
|00000650| 06 00 54 68 69 73 20 63 | 65 6c 6c 27 73 20 63 6f |..This c|ell's co|
|00000660| 6e 74 65 6e 74 73 20 68 | 65 72 65 20 68 61 76 65 |ntents h|ere have|
|00000670| 20 74 68 65 20 73 61 6d | 65 0e 0b 00 34 00 0e 1c | the sam|e...4...|
|00000680| 00 63 61 6c 63 75 6c 61 | 74 69 6f 6e 73 20 61 73 |.calcula|tions as|
|00000690| 20 74 68 65 20 70 72 65 | 76 69 6f 75 73 20 63 65 | the pre|vious ce|
|000006a0| 6c 6c 20 65 78 63 65 70 | 74 20 69 6e 20 74 68 69 |ll excep|t in thi|
|000006b0| 73 20 20 35 00 0e 1c 00 | 63 61 73 65 20 74 68 65 |s 5....|case the|
|000006c0| 20 63 65 6c 6c 20 76 61 | 6c 75 65 20 75 73 65 64 | cell va|lue used|
|000006d0| 20 69 73 20 72 65 66 65 | 72 72 65 64 20 74 6f 20 | is refe|rred to |
|000006e0| 62 79 20 74 68 65 0e 04 | 00 34 00 0e 1c 00 6e 61 |by the..|.4....na|
|000006f0| 6d 65 20 6f 66 20 74 68 | 65 20 63 65 6c 6c 20 72 |me of th|e cell r|
|00000700| 61 74 68 65 72 20 74 68 | 61 6e 20 69 74 73 20 6c |ather th|an its l|
|00000710| 6f 63 61 74 69 6f 6e 2e | 0e 08 00 30 00 0e 4e 00 |ocation.|...0..N.|
|00000720| 03 00 0e 1c 00 50 6c 65 | 61 73 65 20 70 72 65 73 |.....Ple|ase pres|
|00000730| 73 20 74 68 65 20 70 61 | 67 65 20 64 6f 77 6e 20 |s the pa|ge down |
|00000740| 6b 65 79 2e 0e 13 00 25 | 00 0e 4e 00 03 00 0e 4e |key....%|..N....N|
|00000750| 00 03 00 0e 4e 00 03 00 | 0e 4e 00 03 00 0e 4e 00 |....N...|.N....N.|
|00000760| 03 00 0e 4e 00 03 00 0e | 4e 00 03 00 0e 4e 00 03 |...N....|N....N..|
|00000770| 00 0e 4e 00 03 00 0e 4e | 00 03 00 0e 4e 00 03 00 |..N....N|....N...|
|00000780| 0e 4e 00 03 00 0e 07 00 | 61 3d 32 2e 33 20 62 3d |.N......|a=2.3 b=|
|00000790| 31 2e 32 20 63 3d 2d 2e | 32 0e 36 00 17 00 0e 4e |1.2 c=-.|2.6....N|
|000007a0| 00 03 00 0e 12 00 33 2e | 35 30 0e 06 00 54 68 69 |......3.|50...Thi|
|000007b0| 73 20 63 65 6c 6c 73 20 | 63 6f 6e 74 65 6e 74 73 |s cells |contents|
|000007c0| 20 63 6f 6e 74 61 69 6e | 20 72 65 66 65 72 65 6e | contain| referen|
|000007d0| 63 65 20 74 6f 20 76 61 | 72 69 61 62 6c 65 73 3c |ce to va|riables<|
|000007e0| 00 0e 1c 00 77 68 69 63 | 68 20 61 72 65 20 64 65 |....whic|h are de|
|000007f0| 66 69 6e 65 64 20 69 6e | 20 74 68 65 20 73 68 65 |fined in| the she|
|00000800| 65 74 2e 20 54 68 65 73 | 65 20 76 61 72 69 61 62 |et. Thes|e variab|
|00000810| 6c 65 73 20 20 20 35 00 | 0e 1c 00 63 61 6e 20 62 |les 5.|...can b|
|00000820| 65 20 63 68 61 6e 67 65 | 64 20 61 74 20 61 6e 79 |e change|d at any|
|00000830| 20 74 69 6d 65 20 61 6e | 64 20 74 68 65 20 63 65 | time an|d the ce|
|00000840| 6c 6c 0e 0b 00 2d 00 0e | 1c 00 72 65 65 76 61 6c |ll...-..|..reeval|
|00000850| 75 61 74 65 64 20 62 79 | 20 70 72 65 73 73 69 6e |uated by| pressin|
|00000860| 67 20 46 37 20 77 69 74 | 68 20 74 68 65 20 63 75 |g F7 wit|h the cu|
|00000870| 72 73 6f 72 20 6f 6e 20 | 74 68 65 20 35 00 0e 1c |rsor on |the 5...|
|00000880| 00 63 65 6c 6c 20 6a 75 | 73 74 20 74 6f 20 65 76 |.cell ju|st to ev|
|00000890| 61 6c 75 61 74 65 20 74 | 68 61 74 20 63 65 6c 6c |aluate t|hat cell|
|000008a0| 20 6f 72 20 62 79 20 70 | 72 65 73 73 69 6e 67 0e | or by p|ressing.|
|000008b0| 04 00 34 00 0e 1c 00 46 | 39 20 74 6f 20 65 76 61 |..4....F|9 to eva|
|000008c0| 6c 75 61 74 65 20 61 6c | 6c 20 74 68 65 20 63 65 |luate al|l the ce|
|000008d0| 6c 6c 73 20 6f 6e 20 74 | 68 65 20 73 68 65 65 74 |lls on t|he sheet|
|000008e0| 2e 0e 08 00 30 00 0e 4e | 00 03 00 0e 1c 00 50 6c |....0..N|......Pl|
|000008f0| 65 61 73 65 20 70 72 65 | 73 73 20 74 68 65 20 70 |ease pre|ss the p|
|00000900| 61 67 65 20 64 6f 77 6e | 20 6b 65 79 2e 0e 13 00 |age down| key....|
|00000910| 25 00 0e 4e 00 03 00 0e | 4e 00 03 00 0e 4e 00 03 |%..N....|N....N..|
|00000920| 00 0e 4e 00 03 00 0e 4e | 00 03 00 0e 4e 00 03 00 |..N....N|....N...|
|00000930| 0e 4e 00 03 00 0e 4e 00 | 03 00 0e 4e 00 03 00 0e |.N....N.|...N....|
|00000940| 4e 00 03 00 0e 08 00 35 | 2e 36 0e 04 00 37 2e 38 |N......5|.6...7.8|
|00000950| 0e 3c 00 0f 00 0e 4e 00 | 03 00 0e 12 00 30 2e 37 |.<....N.|.....0.7|
|00000960| 32 0e 06 00 54 68 69 73 | 20 63 65 6c 6c 20 63 6f |2...This| cell co|
|00000970| 6e 74 61 69 6e 73 20 61 | 20 72 65 66 65 72 65 6e |ntains a| referen|
|00000980| 63 65 20 74 6f 20 61 20 | 6c 6f 63 61 74 69 6f 6e |ce to a |location|
|00000990| 20 6f 6e 20 20 20 3c 00 | 0e 1c 00 74 68 65 20 73 | on <.|...the s|
|000009a0| 68 65 65 74 2e 20 48 6f | 77 65 76 65 72 20 69 6e |heet. Ho|wever in|
|000009b0| 20 74 68 69 73 20 63 61 | 73 65 20 61 20 6e 75 6d | this ca|se a num|
|000009c0| 62 65 72 20 72 61 74 68 | 65 72 20 20 20 35 00 0e |ber rath|er 5..|
|000009d0| 1c 00 74 68 61 6e 20 61 | 20 63 65 6c 6c 20 69 73 |..than a| cell is|
|000009e0| 20 61 74 20 74 68 65 20 | 72 65 66 65 72 72 65 64 | at the |referred|
|000009f0| 20 74 6f 20 6c 6f 63 61 | 74 69 6f 6e 2e 20 46 52 | to loca|tion. FR|
|00000a00| 45 45 20 26 35 00 0e 1c | 00 45 41 53 59 20 77 69 |EE &5...|.EASY wi|
|00000a10| 6c 6c 20 75 73 65 20 74 | 68 65 20 6e 75 6d 62 65 |ll use t|he numbe|
|00000a20| 72 20 66 6f 75 6e 64 20 | 69 66 20 6e 6f 20 63 65 |r found |if no ce|
|00000a30| 6c 6c 20 69 73 0e 06 00 | 32 00 0e 1c 00 66 6f 75 |ll is...|2....fou|
|00000a40| 6e 64 2e 0e 2c 00 0c 00 | 0e 4e 00 03 00 0e 1c 00 |nd..,...|.N......|
|00000a50| 50 6c 65 61 73 65 20 70 | 72 65 73 73 20 74 68 65 |Please p|ress the|
|00000a60| 20 70 61 67 65 20 64 6f | 77 6e 20 6b 65 79 2e 0e | page do|wn key..|
|00000a70| 13 00 25 00 0e 4e 00 03 | 00 0e 4e 00 03 00 0e 4e |..%..N..|..N....N|
|00000a80| 00 03 00 0e 4e 00 03 00 | 0e 4e 00 03 00 0e 4e 00 |....N...|.N....N.|
|00000a90| 03 00 0e 4e 00 03 00 0e | 4e 00 03 00 0e 4e 00 03 |...N....|N....N..|
|00000aa0| 00 0e 4e 00 03 00 0e 4e | 00 03 00 0e 4e 00 03 00 |..N....N|....N...|
|00000ab0| 0e 4e 00 03 00 0e 07 00 | 2a 2a 2a 2a 2a 2a 2a 0e |.N......|*******.|
|00000ac0| 0e 00 49 6e 20 74 68 69 | 73 20 63 65 6c 6c 20 74 |..In thi|s cell t|
|00000ad0| 68 65 20 64 69 73 70 6c | 61 79 20 69 73 20 66 69 |he displ|ay is fi|
|00000ae0| 6c 6c 65 64 20 77 69 74 | 68 20 2a 27 73 2e 20 54 |lled wit|h *'s. T|
|00000af0| 68 69 73 20 3f 00 0e 1c | 00 6d 65 61 6e 73 20 74 |his ?...|.means t|
|00000b00| 68 65 20 64 69 73 70 6c | 61 79 20 66 6f 72 20 74 |he displ|ay for t|
|00000b10| 68 65 20 63 65 6c 6c 20 | 63 61 6e 6e 6f 74 20 61 |he cell |cannot a|
|00000b20| 63 63 6f 6d 6d 6f 64 61 | 74 65 20 35 00 0e 1c 00 |ccommoda|te 5....|
|00000b30| 74 68 65 20 76 61 6c 75 | 65 20 74 68 65 20 63 65 |the valu|e the ce|
|00000b40| 6c 6c 20 68 61 73 2e 20 | 57 69 74 68 20 74 68 65 |ll has. |With the|
|00000b50| 20 63 75 72 73 6f 72 20 | 6f 6e 20 74 68 65 0e 04 | cursor |on the..|
|00000b60| 00 34 00 0e 1c 00 63 65 | 6c 6c 20 75 73 65 20 74 |.4....ce|ll use t|
|00000b70| 68 65 20 22 41 64 64 2f | 4d 6f 64 69 66 79 20 63 |he "Add/|Modify c|
|00000b80| 65 6c 6c 20 2e 2e 2e 22 | 20 63 6f 6d 6d 61 6e 64 |ell ..."| command|
|00000b90| 20 69 6e 20 74 68 65 20 | 35 00 0e 1c 00 22 43 65 | in the |5...."Ce|
|00000ba0| 6c 6c 22 20 6d 65 6e 75 | 20 74 6f 20 61 64 6a 75 |ll" menu| to adju|
|00000bb0| 73 74 20 74 68 65 20 63 | 65 6c 6c 20 73 69 7a 65 |st the c|ell size|
|00000bc0| 20 73 6f 20 74 68 65 20 | 76 61 6c 75 65 20 20 35 | so the |value 5|
|00000bd0| 00 0e 1c 00 77 69 6c 6c | 20 66 69 74 20 69 6e 20 |....will| fit in |
|00000be0| 74 68 65 20 63 65 6c 6c | 2e 20 59 6f 75 20 63 61 |the cell|. You ca|
|00000bf0| 6e 20 61 6c 73 6f 20 65 | 78 70 65 72 69 6d 65 6e |n also e|xperimen|
|00000c00| 74 20 77 69 74 68 35 00 | 0e 1c 00 6f 74 68 65 72 |t with5.|...other|
|00000c10| 20 64 69 73 70 6c 61 79 | 20 66 6f 72 6d 61 74 73 | display| formats|
|00000c20| 20 61 76 61 69 6c 61 62 | 6c 65 0e 13 00 25 00 0e | availab|le...%..|
|00000c30| 4e 00 03 00 0e 1c 00 50 | 6c 65 61 73 65 20 70 72 |N......P|lease pr|
|00000c40| 65 73 73 20 74 68 65 20 | 70 61 67 65 20 64 6f 77 |ess the |page dow|
|00000c50| 6e 20 6b 65 79 2e 0e 13 | 00 25 00 0e 4e 00 03 00 |n key...|.%..N...|
|00000c60| 0e 4e 00 03 00 0e 4e 00 | 03 00 0e 4e 00 03 00 0e |.N....N.|...N....|
|00000c70| 4e 00 03 00 0e 4e 00 03 | 00 0e 4e 00 03 00 0e 1c |N....N..|..N.....|
|00000c80| 00 41 6e 20 65 78 61 6d | 70 6c 65 20 69 73 20 67 |.An exam|ple is g|
|00000c90| 69 76 65 6e 20 68 65 72 | 65 20 6f 66 20 61 6e 20 |iven her|e of an |
|00000ca0| 65 76 61 6c 75 61 74 69 | 6f 6e 20 65 72 72 6f 72 |evaluati|on error|
|00000cb0| 2e 20 20 35 00 0e 1c 00 | 57 68 65 6e 20 79 6f 75 |. 5....|When you|
|00000cc0| 20 61 64 64 20 61 20 63 | 65 6c 6c 20 74 6f 20 74 | add a c|ell to t|
|00000cd0| 68 65 20 73 68 65 65 74 | 20 46 52 45 45 20 26 20 |he sheet| FREE & |
|00000ce0| 45 41 53 59 0e 06 00 32 | 00 0e 07 00 78 3d 30 0e |EASY...2|....x=0.|
|00000cf0| 12 00 63 68 65 63 6b 73 | 20 74 6f 20 6d 61 6b 65 |..checks| to make|
|00000d00| 20 73 75 72 65 20 74 68 | 65 20 63 6f 72 72 65 63 | sure th|e correc|
|00000d10| 74 20 73 79 6e 74 61 78 | 20 69 73 20 75 73 65 64 |t syntax| is used|
|00000d20| 20 61 6e 64 3b 00 0e 1c | 00 74 65 6c 6c 73 20 79 | and;...|.tells y|
|00000d30| 6f 75 20 69 66 20 6e 6f | 74 2e 20 49 6e 20 74 68 |ou if no|t. In th|
|00000d40| 69 73 20 63 61 73 65 20 | 74 68 65 20 63 6f 72 72 |is case |the corr|
|00000d50| 65 63 74 20 73 79 6e 74 | 61 78 20 35 00 0e 12 00 |ect synt|ax 5....|
|00000d60| 30 2e 30 30 0e 06 00 69 | 73 20 75 73 65 64 20 62 |0.00...i|s used b|
|00000d70| 75 74 20 75 70 6f 6e 20 | 63 65 6c 6c 20 65 76 61 |ut upon |cell eva|
|00000d80| 6c 75 61 74 69 6f 6e 20 | 61 6e 20 65 76 61 6c 75 |luation |an evalu|
|00000d90| 61 74 69 6f 6e 0e 04 00 | 3b 00 0e 1c 00 65 72 72 |ation...|;....err|
|00000da0| 6f 72 20 6f 63 63 75 72 | 73 20 28 64 69 76 69 73 |or occur|s (divis|
|00000db0| 69 6f 6e 20 62 79 20 7a | 65 72 6f 20 69 6e 20 74 |ion by z|ero in t|
|00000dc0| 68 69 73 20 63 61 73 65 | 29 2e 20 49 66 20 20 35 |his case|). If 5|
|00000dd0| 00 0e 1c 00 74 68 69 73 | 20 68 61 70 70 65 6e 73 |....this| happens|
|00000de0| 20 74 68 65 20 76 61 6c | 75 65 20 30 20 69 73 20 | the val|ue 0 is |
|00000df0| 67 69 76 65 6e 20 74 6f | 20 74 68 65 20 63 65 6c |given to| the cel|
|00000e00| 6c 20 61 6e 64 20 35 00 | 0e 1c 00 61 20 65 76 61 |l and 5.|...a eva|
|00000e10| 6c 75 61 74 69 6f 6e 20 | 65 72 72 6f 72 20 6d 65 |luation |error me|
|00000e20| 73 73 61 67 65 20 69 73 | 20 67 69 76 65 6e 20 64 |ssage is| given d|
|00000e30| 65 73 63 72 69 62 69 6e | 67 20 74 68 65 35 00 0e |escribin|g the5..|
|00000e40| 1c 00 65 72 72 6f 72 2e | 20 54 72 79 20 70 6c 61 |..error.| Try pla|
|00000e50| 63 69 6e 67 20 74 68 65 | 20 63 75 72 73 6f 72 20 |cing the| cursor |
|00000e60| 6f 6e 20 74 68 65 20 63 | 65 6c 6c 20 61 6e 64 0e |on the c|ell and.|
|00000e70| 05 00 33 00 0e 1c 00 70 | 72 65 73 73 69 6e 67 20 |..3....p|ressing |
|00000e80| 46 37 2e 20 52 65 6d 65 | 6d 62 65 72 20 74 68 61 |F7. Reme|mber tha|
|00000e90| 74 20 77 68 65 6e 20 79 | 6f 75 20 67 65 74 20 61 |t when y|ou get a|
|00000ea0| 6e 79 20 65 72 72 6f 72 | 20 35 00 0e 1c 00 6f 72 |ny error| 5....or|
|00000eb0| 20 77 61 72 6e 69 6e 67 | 20 69 6e 20 61 20 46 52 | warning| in a FR|
|00000ec0| 45 45 20 26 20 45 41 53 | 59 20 73 65 73 73 69 6f |EE & EAS|Y sessio|
|00000ed0| 6e 20 79 6f 75 20 63 61 | 6e 20 61 6c 77 61 79 73 |n you ca|n always|
|00000ee0| 35 00 0e 1c 00 70 72 65 | 73 73 20 46 31 20 74 6f |5....pre|ss F1 to|
|00000ef0| 20 67 65 74 20 6d 6f 72 | 65 20 69 6e 66 6f 72 6d | get mor|e inform|
|00000f00| 61 74 69 6f 6e 2e 0e 11 | 00 27 00 0e 4e 00 03 00 |ation...|.'..N...|
|00000f10| 0e 1c 00 50 6c 65 61 73 | 65 20 70 72 65 73 73 20 |...Pleas|e press |
|00000f20| 74 68 65 20 70 61 67 65 | 20 64 6f 77 6e 20 6b 65 |the page| down ke|
|00000f30| 79 2e 0e 13 00 25 00 0e | 4e 00 03 00 0e 4e 00 03 |y....%..|N....N..|
|00000f40| 00 0e 07 00 61 31 3d 33 | 2e 35 20 20 61 32 3d 33 |....a1=3|.5 a2=3|
|00000f50| 2e 34 0e 39 00 14 00 0e | 4e 00 03 00 0e 09 00 32 |.4.9....|N......2|
|00000f60| 2e 39 20 20 33 2e 31 0e | 3d 00 0e 00 0e 09 00 33 |.9 3.1.|=......3|
|00000f70| 2e 34 0e 42 00 09 00 0e | 09 00 32 2e 31 20 20 20 |.4.B....|..2.1 |
|00000f80| 61 31 0e 3d 00 0e 00 0e | 0e 00 61 32 0e 3e 00 08 |a1.=....|..a2.>..|
|00000f90| 00 0e 0e 00 33 2e 34 0e | 3d 00 09 00 0e 4e 00 03 |....3.4.|=....N..|
|00000fa0| 00 0e 12 00 33 2e 31 31 | 0e 06 00 54 68 69 73 20 |....3.11|...This |
|00000fb0| 63 65 6c 6c 20 63 6f 6e | 74 61 69 6e 73 20 61 20 |cell con|tains a |
|00000fc0| 66 75 6e 63 74 69 6f 6e | 20 63 61 6c 6c 65 64 20 |function| called |
|00000fd0| 61 20 72 61 6e 67 65 0e | 06 00 39 00 0e 1c 00 66 |a range.|..9....f|
|00000fe0| 75 6e 63 74 69 6f 6e 2e | 20 54 68 65 20 72 61 6e |unction.| The ran|
|00000ff0| 67 65 20 69 73 20 6e 61 | 6d 65 64 20 22 72 31 22 |ge is na|med "r1"|
|00001000| 20 61 6e 64 20 69 73 0e | 0a 00 2e 00 0e 1c 00 68 | and is.|.......h|
|00001010| 69 67 68 6c 69 67 68 74 | 65 64 20 28 69 66 20 79 |ighlight|ed (if y|
|00001020| 6f 75 20 6c 6f 61 64 65 | 64 20 74 68 65 20 66 69 |ou loade|d the fi|
|00001030| 6c 65 20 43 45 4c 4c 2e | 4d 41 4b 29 20 49 66 20 |le CELL.|MAK) If |
|00001040| 20 35 00 0e 1c 00 69 74 | 20 69 73 20 6e 6f 74 20 | 5....it| is not |
|00001050| 68 69 67 68 6c 69 67 68 | 74 65 64 20 75 73 65 20 |highligh|ted use |
|00001060| 74 68 65 20 22 53 68 6f | 77 20 2e 2e 22 20 63 6f |the "Sho|w .." co|
|00001070| 6d 6d 61 6e 64 20 69 6e | 35 00 0e 1c 00 74 68 65 |mmand in|5....the|
|00001080| 20 22 52 61 6e 67 65 22 | 20 6d 65 6e 75 2e 20 54 | "Range"| menu. T|
|00001090| 68 69 73 20 70 61 72 74 | 69 63 75 6c 61 72 20 72 |his part|icular r|
|000010a0| 61 6e 67 65 20 66 75 6e | 63 74 69 6f 6e 20 20 35 |ange fun|ction 5|
|000010b0| 00 0e 1c 00 63 61 6c 63 | 75 6c 61 74 65 73 20 74 |....calc|ulates t|
|000010c0| 68 65 20 61 76 65 72 61 | 67 65 20 6f 66 20 61 6c |he avera|ge of al|
|000010d0| 6c 20 76 61 6c 75 65 73 | 20 66 6f 75 6e 64 20 77 |l values| found w|
|000010e0| 69 74 68 69 6e 20 35 00 | 0e 1c 00 74 68 65 20 72 |ithin 5.|...the r|
|000010f0| 61 6e 67 65 2e 20 4e 6f | 74 65 20 74 68 61 74 20 |ange. No|te that |
|00001100| 74 68 65 20 76 61 6c 75 | 65 73 20 66 6f 75 6e 64 |the valu|es found|
|00001110| 20 69 6e 20 74 68 65 20 | 72 61 6e 67 65 35 00 0e | in the |range5..|
|00001120| 1c 00 63 61 6e 20 62 65 | 20 6e 75 6d 62 65 72 73 |..can be| numbers|
|00001130| 2c 20 76 61 72 69 61 62 | 6c 65 73 20 6f 72 20 6f |, variab|les or o|
|00001140| 74 68 65 72 20 63 65 6c | 6c 73 2e 20 54 68 65 73 |ther cel|ls. Thes|
|00001150| 65 20 20 20 35 00 0e 1c | 00 76 61 6c 75 65 73 20 |e 5...|.values |
|00001160| 63 61 6e 20 61 70 70 65 | 61 72 20 61 6e 79 77 68 |can appe|ar anywh|
|00001170| 65 72 65 20 77 69 74 68 | 69 6e 20 74 68 65 20 72 |ere with|in the r|
|00001180| 61 6e 67 65 2e 0e 06 00 | 32 00 0e 4e 00 03 00 0e |ange....|2..N....|
|00001190| 1c 00 50 6c 65 61 73 65 | 20 70 72 65 73 73 20 74 |..Please| press t|
|000011a0| 68 65 20 70 61 67 65 20 | 64 6f 77 6e 20 6b 65 79 |he page |down key|
|000011b0| 2e 0e 13 00 25 00 0e 4e | 00 03 00 0e 4e 00 03 00 |....%..N|....N...|
|000011c0| 0e 4e 00 03 00 0e 4e 00 | 03 00 0e 4e 00 03 00 0e |.N....N.|...N....|
|000011d0| 07 00 50 3d 31 30 30 30 | 30 30 0e 3f 00 0e 00 0e |..P=1000|00.?....|
|000011e0| 07 00 69 3d 39 2e 37 35 | 0e 41 00 0c 00 0e 07 00 |..i=9.75|.A......|
|000011f0| 4e 3d 32 35 0e 43 00 0a | 00 0e 4e 00 03 00 0e 10 |N=25.C..|..N.....|
|00001200| 00 39 30 30 2e 34 37 0e | 06 00 54 68 69 73 20 63 |.900.47.|..This c|
|00001210| 65 6c 6c 20 73 68 6f 77 | 73 20 6f 6e 65 20 6f 66 |ell show|s one of|
|00001220| 20 74 68 65 20 66 69 6e | 61 6e 63 69 61 6c 20 66 | the fin|ancial f|
|00001230| 75 6e 63 74 69 6f 6e 73 | 0e 04 00 3d 00 0e 1c 00 |unctions|...=....|
|00001240| 61 76 61 69 6c 61 62 6c | 65 20 69 6e 20 46 52 45 |availabl|e in FRE|
|00001250| 45 20 26 20 45 41 53 59 | 2e 20 54 68 69 73 20 66 |E & EASY|. This f|
|00001260| 75 6e 63 74 69 6f 6e 0e | 0b 00 2d 00 0e 1c 00 63 |unction.|..-....c|
|00001270| 61 6c 63 75 6c 61 74 65 | 73 20 61 20 6d 6f 72 74 |alculate|s a mort|
|00001280| 67 61 67 65 20 70 61 79 | 6d 65 6e 74 20 79 6f 75 |gage pay|ment you|
|00001290| 20 63 61 6e 20 61 64 6a | 75 73 74 20 74 68 65 20 | can adj|ust the |
|000012a0| 20 35 00 0e 1c 00 70 72 | 69 6e 63 69 70 6c 65 20 | 5....pr|inciple |
|000012b0| 28 50 29 2c 20 74 68 65 | 20 69 6e 74 65 72 65 73 |(P), the| interes|
|000012c0| 74 20 72 61 74 65 20 28 | 69 29 20 61 6e 64 20 74 |t rate (|i) and t|
|000012d0| 68 65 0e 06 00 32 00 0e | 1c 00 6e 75 6d 62 65 72 |he...2..|..number|
|000012e0| 20 6f 66 20 79 65 61 72 | 73 20 28 4e 29 2e 20 49 | of year|s (N). I|
|000012f0| 6e 20 74 68 69 73 20 63 | 61 73 65 20 74 68 65 20 |n this c|ase the |
|00001300| 6e 75 6d 62 65 72 20 6f | 66 20 20 20 35 00 0e 1c |number o|f 5...|
|00001310| 00 70 61 79 6d 65 6e 74 | 73 20 69 73 20 73 65 74 |.payment|s is set|
|00001320| 20 61 74 20 31 32 20 70 | 65 72 20 79 65 61 72 2e | at 12 p|er year.|
|00001330| 20 48 6f 77 65 76 65 72 | 20 74 68 69 73 20 63 61 | However| this ca|
|00001340| 6e 20 20 35 00 0e 1c 00 | 62 65 20 63 68 61 6e 67 |n 5....|be chang|
|00001350| 65 73 20 61 6c 73 6f 2e | 20 4e 6f 74 69 63 65 20 |es also.| Notice |
|00001360| 74 68 61 74 20 74 68 65 | 20 76 61 72 69 61 62 6c |that the| variabl|
|00001370| 65 73 20 61 72 65 0e 04 | 00 34 00 0e 1c 00 63 61 |es are..|.4....ca|
|00001380| 73 65 20 73 65 6e 73 69 | 74 69 76 65 2e 20 49 66 |se sensi|tive. If|
|00001390| 20 79 6f 75 20 63 68 61 | 6e 67 65 20 50 20 74 6f | you cha|nge P to|
|000013a0| 20 70 20 61 6e 64 20 65 | 76 61 6c 75 61 74 65 64 | p and e|valuated|
|000013b0| 35 00 0e 1c 00 74 68 65 | 20 63 65 6c 6c 20 79 6f |5....the| cell yo|
|000013c0| 75 20 77 6f 75 6c 64 20 | 67 65 74 20 61 6e 20 65 |u would |get an e|
|000013d0| 76 61 6c 75 61 74 69 6f | 6e 20 65 72 72 6f 72 2e |valuatio|n error.|
|000013e0| 0e 07 00 31 00 0e 4e 00 | 03 00 0e 4e 00 03 00 0e |...1..N.|...N....|
|000013f0| 4e 00 03 00 0e 4e 00 03 | 00 0e 4e 00 03 00 0e 4e |N....N..|..N....N|
|00001400| 00 03 00 0e 4e 00 03 00 | 0e 4e 00 03 00 0e 4e 00 |....N...|.N....N.|
|00001410| 03 00 0e 4e 00 03 00 0e | 4e 00 03 00 0e 4e 00 03 |...N....|N....N..|
|00001420| 00 0e 4e 00 03 00 0e 4e | 00 03 00 0e 4e 00 03 00 |..N....N|....N...|
|00001430| 0e 4e 00 03 00 0e 4e 00 | 03 00 0e 4e 00 03 00 0e |.N....N.|...N....|
|00001440| 00 08 00 16 00 22 00 08 | 00 16 00 36 00 08 00 16 |....."..|...6....|
|00001450| 00 4a 00 08 00 16 00 5e | 00 08 00 16 00 72 00 08 |.J.....^|.....r..|
|00001460| 00 0e 00 86 00 08 00 16 | 00 9a 00 08 00 16 00 ae |........|........|
|00001470| 00 08 00 16 00 14 ae 47 | e1 7a 14 06 40 0f 02 01 |.......G|.z..@...|
|00001480| 01 00 00 00 00 63 65 6c | 6c 31 00 32 2e 33 2a 31 |.....cel|l1.2.3*1|
|00001490| 2e 32 00 1e 00 14 ae 47 | e1 7a 14 0e 40 0f 02 01 |.2.....G|.z..@...|
|000014a0| 01 00 00 00 00 00 31 2b | 21 30 30 31 34 21 30 30 |......1+|!0014!00|
|000014b0| 30 38 00 1e 00 00 00 00 | 00 00 00 00 00 0f 02 01 |08......|........|
|000014c0| 01 00 00 00 00 00 31 2b | 63 65 6c 6c 31 00 19 00 |......1+|cell1...|
|000014d0| 00 00 00 00 00 00 00 00 | 0f 02 01 01 00 00 00 00 |........|........|
|000014e0| 00 61 2b 62 2b 63 00 17 | 00 97 6f f9 96 6f f9 e6 |.a+b+c..|..o..o..|
|000014f0| 3f 0f 02 01 01 00 00 00 | 00 00 21 30 30 39 32 21 |?.......|..!0092!|
|00001500| 30 30 30 39 2f 21 30 30 | 39 32 21 30 30 31 36 00 |0009/!00|92!0016.|
|00001510| 27 00 00 00 00 00 80 23 | f1 40 07 02 01 01 00 00 |'......#|.@......|
|00001520| 00 00 00 33 30 30 2a 32 | 33 34 00 19 00 00 00 00 |...300*2|34......|
|00001530| 00 00 00 00 00 0f 02 01 | 01 00 00 00 00 00 32 2e |........|......2.|
|00001540| 34 35 2f 78 00 18 00 00 | 00 00 00 00 00 00 00 0f |45/x....|........|
|00001550| 02 01 01 00 00 00 00 00 | 41 56 52 28 72 31 29 00 |........|AVR(r1).|
|00001560| 19 00 00 00 00 00 00 00 | 00 00 0f 02 01 01 00 00 |........|........|
|00001570| 00 00 00 4d 54 47 28 50 | 2c 69 2c 4e 2c 31 32 29 |...MTG(P|,i,N,12)|
|00001580| 00 1f 00 72 31 00 93 00 | 08 00 98 00 14 00 0b 00 |...r1...|........|
|00001590| 45 4e 44 00 | |END. | |
+--------+-------------------------+-------------------------+--------+--------+
